This routin will export the content of a worksheet to a text (CSV) file. ˜param XLS The XLSReadWriteII object to export. ˜param SheetIndex Index of the work sheet to export. ˜param QuoteChar Quote character for text strings. ˜param SeparatorChar The character used to separate the cell values (fields) in the file. Common used characters are comma, semicolon and tab. ˜param Options File export options. ˜param Filename The name of the file that the cells shall be exported to.
This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. Correct value for decimal separator is detected automatically. See alse ˜[link ImportCSVAuto] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param SepChar Separator character for the fields (cells) in the source file. ˜param HasQuoteChar Set this to True if strings in the source file are quoted. ˜result The number of cells that where imported.
This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. The routine will try to detect correct values for separator character, quote character and decimal separator. See alse ˜[link ImportCSV] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜result The number of cells that where imported.
This routine will import a table <TABLE> tag from a html file into a worksheet. Any existing cells on the worksheet will be overwritten. ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param TableIndex The zero based index of which table (if there is more than one) that shall be imported. If TableIndex is set to -1, all tables will be imported. ˜param SpecialDecode Default set to False. Don't change this. ˜param DecSep Decimal separator character. Default is the Delphi DecimalSeparator global variable value. Change this if numeric values not are imported correct. ˜result True if any cells where imported.
Base class for objects that manipulates cell areas. Solid areas are areas that not can be splitted by delete/insert/move operations, such as merged cells.
Event fired when ˜[link TXLSDbRead4] reads a cell. ˜param Sender The TXLSDbRead4 object. ˜param IsFieldNames True if the cell is a field name. ˜param Dataset The source data set. ˜param FieldIndex Index into the source data set's field list. ˜param Col The column in the destination XLSReadWriteII object where the cell is inserted. ˜param Row The row in the destination XLSReadWriteII object where the cell is inserted.